Tabela PhStDocDecree

Definicja tabeli PhStDocDecree

Name

PhStDocDecree

Code

PhStDocDecree

Comment

Tabela do zapisu dekretacji dokumentów


Lista kolumn tabeli PhStDocDecree

Name

Code

StDocDecreeID

StDocDecreeID

StDocID

StDocID

AccountDebit

AccountDebit

AccountCredit

AccountCredit

AmountDebit

AmountDebit

AmountCredit

AmountCredit


Kolumna StDocDecreeID tabeli PhStDocDecree

Definicja kolumny StDocDecreeID tabeli PhStDocDecree

Name

StDocDecreeID

Code

StDocDecreeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StDocID tabeli PhStDocDecree

Definicja kolumny StDocID tabeli PhStDocDecree

Name

StDocID

Code

StDocID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Identyfikator dokumentu którego dotyczy dekretacja


Kolumna AccountDebit tabeli PhStDocDecree

Definicja kolumny AccountDebit tabeli PhStDocDecree

Name

AccountDebit

Code

AccountDebit

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

konto winien


Kolumna AccountCredit tabeli PhStDocDecree

Definicja kolumny AccountCredit tabeli PhStDocDecree

Name

AccountCredit

Code

AccountCredit

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

konto ma


Kolumna AmountDebit tabeli PhStDocDecree

Definicja kolumny AmountDebit tabeli PhStDocDecree

Name

AmountDebit

Code

AmountDebit

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

kwota winien


Kolumna AmountCredit tabeli PhStDocDecree

Definicja kolumny AmountCredit tabeli PhStDocDecree

Name

AmountCredit

Code

AmountCredit

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

kwota ma


Lista kluczy tabeli PhStDocDecree

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhStDocDecree

Definicja klucza Identifier_1 tabeli PhStDocDecree

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment